Diagram UHCContracts_2

Defincja diagramu UHCContracts_2

Name

UHCContracts_2

Code

UHCContracts_2

Comment

 


Lista tabel diagramu

Name

Code

AccountData

AccountData

AccountDataPOZ

AccountDataPOZ

Address

Address

Chemotherapy

Chemotherapy

ChemotherapyInvoice

ChemotherapyInvoice

Contract

Contract

ContractData

ContractData

ContractKind

ContractKind

Contractor

Contractor

ContractService

ContractService

ContractServiceClass

ContractServiceClass

ContractServiceKind

ContractServiceKind

ContractServiceType

ContractServiceType

ContractType

ContractType

Dialysis

Dialysis

EffectCode

EffectCode

Event

Event

GeneralData

GeneralData

GeneralDataType

GeneralDataType

HierarchyType

HierarchyType

Hospital

Hospital

Insurance

Insurance

InsuranceDocument

InsuranceDocument

Insurer

Insurer

Invoice

Invoice

LAccountDataEffectCode

LAccountDataEffectCode

LContract

LContract

LContractDataADMCode

LContractDataADMCode

LContractorGeneralData

LContractorGeneralData

LContractServContractData

LContractServContractData

LContractServiceClass

LContractServiceClass

LContractServOrgUnitContr

LContractServOrgUnitContr

Leave

Leave

LimitType

LimitType

LOrgUnit

LOrgUnit

LOrgUnitAddress

LOrgUnitAddress

OrgUnit

OrgUnit

ParamType

ParamType

TreatmentSchema

TreatmentSchema


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_24

R_24

ContractServiceKind

ContractService

ContractServiceKindID

 

 

R_26

R_26

ContractServiceType

ContractService

ContractServiceTypeID

 

 

R_29

R_29

ContractService

LContractServiceClass

ContractServID

 

 

R_30

R_30

ContractServiceClass

LContractServiceClass

ContractServiceClassID

 

 

R_32

R_32

ContractData

LContractServOrgUnitContr

ContractDataID

 

 

R_33

R_33

Contractor

LContractServOrgUnitContr

ContractorID

 

 

R_34

R_34

ContractService

LContractServOrgUnitContr

ContractServID

 

 

R_35

R_35

Insurer

Contractor

InsurerID

 

 

R_36

R_36

Contract

ContractData

ContractID

 

 

R_41

R_41

OrgUnit

LContractServOrgUnitContr

OrgUnitID

 

 

R_42

R_42

HierarchyType

OrgUnit

HierarchyTypeID

 

 

R_44

R_44

OrgUnit

LOrgUnit

OrgUnitID

 

 

R_45

R_45

OrgUnit

LOrgUnit

Org_OrgUnitID

 

 

R_46

R_46

ContractService

AccountData

ContractServID

 

 

R_47

R_47

ContractService

AccountData

Con_ContractServID

 

 

R_48

R_48

OrgUnit

Event

OrgUnitID

 

 

R_55

R_55

OrgUnit

LOrgUnitAddress

OrgUnitID

 

 

R_56

R_56

Address

LOrgUnitAddress

AddressID

 

 

R_67

R_67

ContractType

Contract

ContractTypeID

 

 

R_100

R_100

Contract

LContract

ContractID

 

 

R_101

R_101

Contract

LContract

Con_ContractID

 

 

R_102

R_102

ContractKind

Contract

ContractKindID

 

 

R_127

R_127

ContractData

LContractServContractData

ContractDataID

 

 

R_128

R_128

ContractService

LContractServContractData

ContractServID

 

 

R_145

R_145

Dialysis

AccountData

DialysisID

 

 

R_146

R_146

AccountDataPOZ

AccountData

AccountDataPOZID

 

 

R_147

R_147

TreatmentSchema

Chemotherapy

TreatmentSchemaID

 

 

R_148

R_148

ParamType

Chemotherapy

ParamTypeID

 

 

R_149

R_149

Chemotherapy

AccountData

ChemotherapyID

 

 

R_150

R_150

Insurance

AccountData

InsuranceID

 

 

R_159

R_159

Hospital

GeneralData

HospitalID

 

 

R_160

R_160

GeneralDataType

GeneralData

GeneralDataTypeID

 

 

R_161

R_161

Contractor

LContractorGeneralData

ContractorID

 

 

R_162

R_162

GeneralData

LContractorGeneralData

GeneralDataID

 

 

R_163

R_163

EffectCode

LAccountDataEffectCode

EffectCodeID

 

 

R_164

R_164

AccountData

LAccountDataEffectCode

AccountDataID

 

 

R_188

R_188

Invoice

AccountData

InvoiceID

 

 

R_300

R_300

Address

Contractor

AddressID

 

 

R_412

R_412

Event

Leave

EventID

 

 

R_470

R_470

Insurance

InsuranceDocument

InsuranceID

 

 

R_550

R_550

Chemotherapy

ChemotherapyInvoice

ChemotherapyID

 

 

R_567

R_567

Address

Contract

AddressID

 

 

R_614

R_614

ContractService

ContractData

LumpSumContractServId

 

 

R_616

R_616

OrgUnit

ContractService

InstitutionOrgUnitId

 

 

R_617

R_617

ContractData

LContractDataADMCode

ContractDataID